package com.zhf.dao;

import com.zhf.bean.Student;

import java.sql.SQLException;
import java.util.List;

/**
 * @Author: ZhaoHuanfeng
 * @Date: 2020/10/17 15:31
 */
public interface StudentDao {
    //通过学号查询学生信息
    public abstract Student getStudentByID(String id) throws SQLException;
    //查看所有学生信息
    public abstract List<Student> getStudents() throws SQLException;
    //添加学生信息
    public abstract int addStudent(Student student) throws SQLException;
    //修改学生信息
    public abstract int updateStudent(Student student) throws SQLException;
    //通过学号删除学生信息
    public abstract int deleteStudentByID(String id) throws SQLException;

    //查询是否有学生在某班级
    public abstract int isStudentInClass(String className) throws SQLException;
}
